/**
 * Created by fangshufeng on 2017/12/6.
 */

const DevelopSQL = {
    search:"SELECT * FROM mock_db.mock_data where relation_id=(?) ORDER BY id DESC",
    update:"UPDATE `mock_db`.`mock_data` SET `name`=(?),`path`=(?), `data`=(?)  WHERE `id`=(?)",
    insert:"INSERT INTO `mock_db`.`mock_data` (`name`, `path`, `data`, `relation_id` ) VALUES ((?), (?), (?), (?));",
    searchOnlyData:"SELECT * FROM mock_db.mock_data where id=(?) and path=(?)",
    delete:'DELETE FROM `mock_db`.`mock_data` WHERE `id`=(?)'
};

module.exports = DevelopSQL;